﻿CREATE PROCEDURE [dbo].[proc_ManagementArea_GetItem]
	(
		@Id int
	)
AS
	--Select Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,ContactPerson,ContactPhone,ContactEmail,WebAddress,Products From ManagementArea Where Id=@Id
Select ma.Id, CompanyName,Startletter,CompanyNumber,CompanyPhone,CompanyFax,CompanyAddress,Zip,
	ContactPerson,ContactPhone,ContactEmail,WebAddress,Products,zid
	 From ManagementArea ma Where Id=@Id
	RETURN
